﻿-- =============================================
-- Script Template
-- =============================================
-- si no se han creado los login
CREATE LOGIN sacm WITH PASSWORD = 'password';
GO
CREATE LOGIN security WITH PASSWORD = 'password';
GO

USE [SACM]

CREATE USER [sacm] FOR LOGIN [sacm]
    WITH DEFAULT_SCHEMA = [sacm];

CREATE USER [security] FOR LOGIN [security]
    WITH DEFAULT_SCHEMA = [security];

-- Se ya se crearon estos usuario, hay que modificarle su login relacionado
--EXEC sp_change_users_login 'Update_One', 'sacm', 'sacm';
--EXEC sp_change_users_login 'Update_One', 'security', 'security';
